Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 10127 |
| Missing cells | 2730 |
| Missing cells (%) | 1.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.6 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Numeric | 15 |
|---|---|
| Categorical | 6 |
customer_age is highly overall correlated with customer_relationship_length | High correlation |
customer_relationship_length is highly overall correlated with customer_age | High correlation |
customer_available_credit_limit is highly overall correlated with remaining_credit_limit | High correlation |
credit_card_debt_balance is highly overall correlated with average_utilization | High correlation |
remaining_credit_limit is highly overall correlated with customer_available_credit_limit and 1 other fields | High correlation |
total_transaction_amount is highly overall correlated with total_transaction_count | High correlation |
total_transaction_count is highly overall correlated with total_transaction_amount | High correlation |
average_utilization is highly overall correlated with credit_card_debt_balance and 1 other fields | High correlation |
customer_sex is highly overall correlated with customer_salary_range | High correlation |
customer_salary_range is highly overall correlated with customer_sex | High correlation |
credit_card_classification is highly imbalanced (79.2%) | Imbalance |
customer_age has 624 (6.2%) missing values | Missing |
customer_sex has 1018 (10.1%) missing values | Missing |
customer_salary_range has 681 (6.7%) missing values | Missing |
total_transaction_amount has 407 (4.0%) missing values | Missing |
customer_number_of_dependents has 904 (8.9%) zeros | Zeros |
contacts_in_last_year has 399 (3.9%) zeros | Zeros |
credit_card_debt_balance has 2470 (24.4%) zeros | Zeros |
average_utilization has 2470 (24.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-01 12:56:41.819381 |
|---|---|
| Analysis finished | 2023-05-01 12:57:13.166809 |
| Duration | 31.35 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
customer_id
Real number (ℝ)
| Distinct | 10076 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 550508.99 |
| Minimum | 100069 |
|---|---|
| Maximum | 999911 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 100069 |
|---|---|
| 5-th percentile | 146834.4 |
| Q1 | 323605 |
| median | 552548 |
| Q3 | 777326 |
| 95-th percentile | 955268.1 |
| Maximum | 999911 |
| Range | 899842 |
| Interquartile range (IQR) | 453721 |
Descriptive statistics
| Standard deviation | 261237.66 |
|---|---|
| Coefficient of variation (CV) | 0.4745384 |
| Kurtosis | -1.2132735 |
| Mean | 550508.99 |
| Median Absolute Deviation (MAD) | 227313 |
| Skewness | -0.0012450197 |
| Sum | 5.5750045 × 109 |
| Variance | 6.8245113 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 585752 | 2 | < 0.1% |
| 551232 | 2 | < 0.1% |
| 515651 | 2 | < 0.1% |
| 101989 | 2 | < 0.1% |
| 167216 | 2 | < 0.1% |
| 113558 | 2 | < 0.1% |
| 356515 | 2 | < 0.1% |
| 944269 | 2 | < 0.1% |
| 901904 | 2 | < 0.1% |
| 260129 | 2 | < 0.1% |
| Other values (10066) | 10107 |
| Value | Count | Frequency (%) |
| 100069 | 1 | |
| 100076 | 1 | |
| 100091 | 1 | |
| 100095 | 1 | |
| 100096 | 1 | |
| 100117 | 1 | |
| 100331 | 1 | |
| 100344 | 1 | |
| 100689 | 1 | |
| 100769 | 1 |
| Value | Count | Frequency (%) |
| 999911 | 1 | |
| 999876 | 1 | |
| 999811 | 1 | |
| 999755 | 1 | |
| 999673 | 1 | |
| 999640 | 1 | |
| 999474 | 1 | |
| 999394 | 1 | |
| 999232 | 1 | |
| 999218 | 1 |
customer_age
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 624 |
| Missing (%) | 6.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.3179 |
| Minimum | 26 |
|---|---|
| Maximum | 73 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 26 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 41 |
| median | 46 |
| Q3 | 52 |
| 95-th percentile | 60 |
| Maximum | 73 |
| Range | 47 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 8.0012274 |
|---|---|
| Coefficient of variation (CV) | 0.1727459 |
| Kurtosis | -0.28227809 |
| Mean | 46.3179 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.036413591 |
| Sum | 440159 |
| Variance | 64.019641 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=45)
| Value | Count | Frequency (%) |
| 44 | 472 | 4.7% |
| 49 | 465 | 4.6% |
| 46 | 459 | 4.5% |
| 45 | 457 | 4.5% |
| 48 | 453 | 4.5% |
| 47 | 446 | 4.4% |
| 43 | 446 | 4.4% |
| 50 | 420 | 4.1% |
| 42 | 400 | 3.9% |
| 52 | 366 | 3.6% |
| Other values (35) | 5119 | |
| (Missing) | 624 | 6.2% |
| Value | Count | Frequency (%) |
| 26 | 74 | |
| 27 | 32 | 0.3% |
| 28 | 23 | 0.2% |
| 29 | 53 | 0.5% |
| 30 | 67 | 0.7% |
| 31 | 86 | |
| 32 | 97 | |
| 33 | 121 | |
| 34 | 138 | |
| 35 | 168 |
| Value | Count | Frequency (%) |
| 73 | 1 | < 0.1% |
| 70 | 1 | < 0.1% |
| 68 | 1 | < 0.1% |
| 67 | 4 | < 0.1% |
| 66 | 2 | < 0.1% |
| 65 | 94 | |
| 64 | 40 | |
| 63 | 59 | |
| 62 | 86 | |
| 61 | 86 |
customer_sex
Categorical
HIGH CORRELATION MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1018 |
| Missing (%) | 10.1% |
| Memory size | 79.2 KiB |
| F | |
|---|---|
| M |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 9109 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | F |
|---|---|
| 2nd row | F |
| 3rd row | M |
| 4th row | F |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| F | 4838 | |
| M | 4271 | |
| (Missing) | 1018 | 10.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| f | 4838 | |
| m | 4271 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 4838 | |
| M | 4271 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 9109 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 4838 | |
| M | 4271 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9109 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 4838 | |
| M | 4271 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9109 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 4838 | |
| M | 4271 |
customer_number_of_dependents
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.3462032 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 904 |
| Zeros (%) | 8.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.2989083 |
|---|---|
| Coefficient of variation (CV) | 0.55362142 |
| Kurtosis | -0.68301665 |
| Mean | 2.3462032 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.020825536 |
| Sum | 23760 |
| Variance | 1.6871629 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 3 | 2732 | |
| 2 | 2655 | |
| 1 | 1838 | |
| 4 | 1574 | |
| 0 | 904 | 8.9% |
| 5 | 424 | 4.2% |
| Value | Count | Frequency (%) |
| 0 | 904 | 8.9% |
| 1 | 1838 | |
| 2 | 2655 | |
| 3 | 2732 | |
| 4 | 1574 | |
| 5 | 424 | 4.2% |
| Value | Count | Frequency (%) |
| 5 | 424 | 4.2% |
| 4 | 1574 | |
| 3 | 2732 | |
| 2 | 2655 | |
| 1 | 1838 | |
| 0 | 904 | 8.9% |
customer_education
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.2 KiB |
| Graduate | |
|---|---|
| High School | |
| Unknown | |
| Uneducated | |
| College | |
| Other values (2) |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 8.9392713 |
| Min length | 7 |
Characters and Unicode
| Total characters | 90528 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | High School |
|---|---|
| 2nd row | Graduate |
| 3rd row | High School |
| 4th row | High School |
| 5th row | High School |
Common Values
| Value | Count | Frequency (%) |
| Graduate | 3128 | |
| High School | 2013 | |
| Unknown | 1519 | |
| Uneducated | 1487 | |
| College | 1013 | 10.0% |
| Post-Graduate | 516 | 5.1% |
| Doctorate | 451 | 4.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| graduate | 3128 | |
| high | 2013 | |
| school | 2013 | |
| unknown | 1519 | |
| uneducated | 1487 | |
| college | 1013 | 8.3% |
| post-graduate | 516 | 4.3% |
| doctorate | 451 | 3.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 9226 | 10.2% |
| e | 9095 | 10.0% |
| o | 7976 | 8.8% |
| d | 6618 | 7.3% |
| t | 6549 | 7.2% |
| n | 6044 | 6.7% |
| u | 5131 | 5.7% |
| r | 4095 | 4.5% |
| l | 4039 | 4.5% |
| h | 4026 | 4.4% |
| Other values (15) | 27729 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 75343 | |
| Uppercase Letter | 12656 | 14.0% |
| Space Separator | 2013 | 2.2% |
| Dash Punctuation | 516 | 0.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 9226 | |
| e | 9095 | |
| o | 7976 | |
| d | 6618 | |
| t | 6549 | |
| n | 6044 | |
| u | 5131 | |
| r | 4095 | 5.4% |
| l | 4039 | 5.4% |
| h | 4026 | 5.3% |
| Other values (6) | 12544 |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 3644 | |
| U | 3006 | |
| S | 2013 | |
| H | 2013 | |
| C | 1013 | 8.0% |
| P | 516 | 4.1% |
| D | 451 | 3.6% |
Space Separator
| Value | Count | Frequency (%) |
| 2013 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 516 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 87999 | |
| Common | 2529 | 2.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 9226 | 10.5% |
| e | 9095 | 10.3% |
| o | 7976 | 9.1% |
| d | 6618 | 7.5% |
| t | 6549 | 7.4% |
| n | 6044 | 6.9% |
| u | 5131 | 5.8% |
| r | 4095 | 4.7% |
| l | 4039 | 4.6% |
| h | 4026 | 4.6% |
| Other values (13) | 25200 |
Common
| Value | Count | Frequency (%) |
| 2013 | ||
| - | 516 | 20.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 90528 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 9226 | 10.2% |
| e | 9095 | 10.0% |
| o | 7976 | 8.8% |
| d | 6618 | 7.3% |
| t | 6549 | 7.2% |
| n | 6044 | 6.7% |
| u | 5131 | 5.7% |
| r | 4095 | 4.5% |
| l | 4039 | 4.5% |
| h | 4026 | 4.4% |
| Other values (15) | 27729 |
customer_civil_status
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.2 KiB |
| Married | |
|---|---|
| Single | |
| Unknown | |
| Divorced |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.6845068 |
| Min length | 6 |
Characters and Unicode
| Total characters | 67694 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Married |
|---|---|
| 2nd row | Unknown |
| 3rd row | Married |
| 4th row | Married |
| 5th row | Single |
Common Values
| Value | Count | Frequency (%) |
| Married | 4687 | |
| Single | 3943 | |
| Unknown | 749 | 7.4% |
| Divorced | 748 | 7.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| married | 4687 | |
| single | 3943 | |
| unknown | 749 | 7.4% |
| divorced | 748 | 7.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 10122 | |
| i | 9378 | |
| e | 9378 | |
| n | 6190 | |
| d | 5435 | |
| M | 4687 | |
| a | 4687 | |
| l | 3943 | 5.8% |
| g | 3943 | 5.8% |
| S | 3943 | 5.8% |
| Other values (7) | 5988 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 57567 | |
| Uppercase Letter | 10127 | 15.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 10122 | |
| i | 9378 | |
| e | 9378 | |
| n | 6190 | |
| d | 5435 | |
| a | 4687 | |
| l | 3943 | 6.8% |
| g | 3943 | 6.8% |
| o | 1497 | 2.6% |
| k | 749 | 1.3% |
| Other values (3) | 2245 | 3.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 4687 | |
| S | 3943 | |
| U | 749 | 7.4% |
| D | 748 | 7.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 67694 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 10122 | |
| i | 9378 | |
| e | 9378 | |
| n | 6190 | |
| d | 5435 | |
| M | 4687 | |
| a | 4687 | |
| l | 3943 | 5.8% |
| g | 3943 | 5.8% |
| S | 3943 | 5.8% |
| Other values (7) | 5988 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 67694 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 10122 | |
| i | 9378 | |
| e | 9378 | |
| n | 6190 | |
| d | 5435 | |
| M | 4687 | |
| a | 4687 | |
| l | 3943 | 5.8% |
| g | 3943 | 5.8% |
| S | 3943 | 5.8% |
| Other values (7) | 5988 |
customer_salary_range
Categorical
HIGH CORRELATION MISSING
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 681 |
| Missing (%) | 6.7% |
| Memory size | 79.2 KiB |
| below 40K | |
|---|---|
| 40-60K | |
| 80-120K | |
| 60-80K | |
| Unknown |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 7.8253229 |
| Min length | 6 |
Characters and Unicode
| Total characters | 73918 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 40-60K |
|---|---|
| 2nd row | below 40K |
| 3rd row | 80-120K |
| 4th row | below 40K |
| 5th row | 80-120K |
Common Values
| Value | Count | Frequency (%) |
| below 40K | 3327 | |
| 40-60K | 1666 | |
| 80-120K | 1436 | |
| 60-80K | 1302 | 12.9% |
| Unknown | 1030 | 10.2% |
| 120K and more | 685 | 6.8% |
| (Missing) | 681 | 6.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| below | 3327 | |
| 40k | 3327 | |
| 40-60k | 1666 | |
| 80-120k | 1436 | |
| 60-80k | 1302 | 9.2% |
| unknown | 1030 | 7.3% |
| 120k | 685 | 4.8% |
| and | 685 | 4.8% |
| more | 685 | 4.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 12820 | |
| K | 8416 | |
| o | 5042 | 6.8% |
| 4 | 4993 | 6.8% |
| 4697 | 6.4% | |
| - | 4404 | 6.0% |
| w | 4357 | 5.9% |
| e | 4012 | 5.4% |
| n | 3775 | 5.1% |
| b | 3327 | 4.5% |
| Other values (11) | 18075 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 27761 | |
| Lowercase Letter | 27610 | |
| Uppercase Letter | 9446 | 12.8% |
| Space Separator | 4697 | 6.4% |
| Dash Punctuation | 4404 | 6.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 5042 | |
| w | 4357 | |
| e | 4012 | |
| n | 3775 | |
| b | 3327 | |
| l | 3327 | |
| k | 1030 | 3.7% |
| a | 685 | 2.5% |
| d | 685 | 2.5% |
| m | 685 | 2.5% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 12820 | |
| 4 | 4993 | 18.0% |
| 6 | 2968 | 10.7% |
| 8 | 2738 | 9.9% |
| 1 | 2121 | 7.6% |
| 2 | 2121 | 7.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| K | 8416 | |
| U | 1030 | 10.9% |
Space Separator
| Value | Count | Frequency (%) |
| 4697 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4404 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 37056 | |
| Common | 36862 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| K | 8416 | |
| o | 5042 | |
| w | 4357 | |
| e | 4012 | |
| n | 3775 | |
| b | 3327 | 9.0% |
| l | 3327 | 9.0% |
| U | 1030 | 2.8% |
| k | 1030 | 2.8% |
| a | 685 | 1.8% |
| Other values (3) | 2055 | 5.5% |
Common
| Value | Count | Frequency (%) |
| 0 | 12820 | |
| 4 | 4993 | 13.5% |
| 4697 | 12.7% | |
| - | 4404 | 11.9% |
| 6 | 2968 | 8.1% |
| 8 | 2738 | 7.4% |
| 1 | 2121 | 5.8% |
| 2 | 2121 | 5.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 73918 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 12820 | |
| K | 8416 | |
| o | 5042 | 6.8% |
| 4 | 4993 | 6.8% |
| 4697 | 6.4% | |
| - | 4404 | 6.0% |
| w | 4357 | 5.9% |
| e | 4012 | 5.4% |
| n | 3775 | 5.1% |
| b | 3327 | 4.5% |
| Other values (11) | 18075 |
customer_relationship_length
Real number (ℝ)
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.928409 |
| Minimum | 13 |
|---|---|
| Maximum | 56 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 13 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 31 |
| median | 36 |
| Q3 | 40 |
| 95-th percentile | 50 |
| Maximum | 56 |
| Range | 43 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 7.9864163 |
|---|---|
| Coefficient of variation (CV) | 0.22228695 |
| Kurtosis | 0.40010012 |
| Mean | 35.928409 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.10656536 |
| Sum | 363847 |
| Variance | 63.782846 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=44)
| Value | Count | Frequency (%) |
| 36 | 2463 | |
| 37 | 358 | 3.5% |
| 34 | 353 | 3.5% |
| 38 | 347 | 3.4% |
| 39 | 341 | 3.4% |
| 40 | 333 | 3.3% |
| 31 | 318 | 3.1% |
| 35 | 317 | 3.1% |
| 33 | 305 | 3.0% |
| 30 | 300 | 3.0% |
| Other values (34) | 4692 |
| Value | Count | Frequency (%) |
| 13 | 70 | |
| 14 | 16 | 0.2% |
| 15 | 34 | 0.3% |
| 16 | 29 | 0.3% |
| 17 | 39 | 0.4% |
| 18 | 58 | |
| 19 | 63 | |
| 20 | 74 | |
| 21 | 83 | |
| 22 | 105 |
| Value | Count | Frequency (%) |
| 56 | 103 | |
| 55 | 42 | 0.4% |
| 54 | 53 | 0.5% |
| 53 | 78 | |
| 52 | 62 | 0.6% |
| 51 | 80 | |
| 50 | 96 | |
| 49 | 141 | |
| 48 | 162 | |
| 47 | 171 |
customer_available_credit_limit
Real number (ℝ)
| Distinct | 6298 |
|---|---|
| Distinct (%) | 62.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10036.344 |
| Minimum | 1438.3 |
|---|---|
| Maximum | 310644 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 1438.3 |
|---|---|
| 5-th percentile | 1449 |
| Q1 | 2578.5 |
| median | 4696 |
| Q3 | 11767.5 |
| 95-th percentile | 34516 |
| Maximum | 310644 |
| Range | 309205.7 |
| Interquartile range (IQR) | 9189 |
Descriptive statistics
| Standard deviation | 17629.707 |
|---|---|
| Coefficient of variation (CV) | 1.7565866 |
| Kurtosis | 139.53768 |
| Mean | 10036.344 |
| Median Absolute Deviation (MAD) | 2732 |
| Skewness | 9.7414553 |
| Sum | 1.0163805 × 108 |
| Variance | 3.1080658 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 34516 | 497 | 4.9% |
| 1438.3 | 496 | 4.9% |
| 15987 | 18 | 0.2% |
| 9959 | 17 | 0.2% |
| 23981 | 12 | 0.1% |
| 12944.7 | 11 | 0.1% |
| 6224 | 11 | 0.1% |
| 310644 | 11 | 0.1% |
| 3735 | 10 | 0.1% |
| 2490 | 10 | 0.1% |
| Other values (6288) | 9034 |
| Value | Count | Frequency (%) |
| 1438.3 | 496 | |
| 1439 | 2 | < 0.1% |
| 1440 | 1 | < 0.1% |
| 1441 | 2 | < 0.1% |
| 1442 | 1 | < 0.1% |
| 1443 | 3 | < 0.1% |
| 1446 | 1 | < 0.1% |
| 1449 | 2 | < 0.1% |
| 1451 | 2 | < 0.1% |
| 1452 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 310644 | 11 | |
| 298098 | 1 | < 0.1% |
| 296334 | 1 | < 0.1% |
| 269667 | 1 | < 0.1% |
| 265959 | 1 | < 0.1% |
| 258057 | 1 | < 0.1% |
| 257445 | 1 | < 0.1% |
| 232938 | 1 | < 0.1% |
| 230409 | 1 | < 0.1% |
| 224883 | 1 | < 0.1% |
credit_card_classification
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.2 KiB |
| Blue | |
|---|---|
| Silver | 555 |
| Gold | 116 |
| Platinum | 20 |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 4.1175077 |
| Min length | 4 |
Characters and Unicode
| Total characters | 41698 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Blue |
|---|---|
| 2nd row | Blue |
| 3rd row | Silver |
| 4th row | Blue |
| 5th row | Blue |
Common Values
| Value | Count | Frequency (%) |
| Blue | 9436 | |
| Silver | 555 | 5.5% |
| Gold | 116 | 1.1% |
| Platinum | 20 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| blue | 9436 | |
| silver | 555 | 5.5% |
| gold | 116 | 1.1% |
| platinum | 20 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 10127 | |
| e | 9991 | |
| u | 9456 | |
| B | 9436 | |
| i | 575 | 1.4% |
| S | 555 | 1.3% |
| v | 555 | 1.3% |
| r | 555 | 1.3% |
| G | 116 | 0.3% |
| o | 116 | 0.3% |
| Other values (6) | 216 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 31571 | |
| Uppercase Letter | 10127 | 24.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 10127 | |
| e | 9991 | |
| u | 9456 | |
| i | 575 | 1.8% |
| v | 555 | 1.8% |
| r | 555 | 1.8% |
| o | 116 | 0.4% |
| d | 116 | 0.4% |
| a | 20 | 0.1% |
| t | 20 | 0.1% |
| Other values (2) | 40 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 9436 | |
| S | 555 | 5.5% |
| G | 116 | 1.1% |
| P | 20 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 41698 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 10127 | |
| e | 9991 | |
| u | 9456 | |
| B | 9436 | |
| i | 575 | 1.4% |
| S | 555 | 1.3% |
| v | 555 | 1.3% |
| r | 555 | 1.3% |
| G | 116 | 0.3% |
| o | 116 | 0.3% |
| Other values (6) | 216 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 41698 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 10127 | |
| e | 9991 | |
| u | 9456 | |
| B | 9436 | |
| i | 575 | 1.4% |
| S | 555 | 1.3% |
| v | 555 | 1.3% |
| r | 555 | 1.3% |
| G | 116 | 0.3% |
| o | 116 | 0.3% |
| Other values (6) | 216 | 0.5% |
total_products
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1473289 |
| Minimum | 1 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 36 |
| Range | 35 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.1834766 |
|---|---|
| Coefficient of variation (CV) | 0.76759686 |
| Kurtosis | 50.052262 |
| Mean | 4.1473289 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 6.0283963 |
| Sum | 42000 |
| Variance | 10.134524 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 3 | 2264 | |
| 4 | 1874 | |
| 5 | 1863 | |
| 6 | 1847 | |
| 2 | 1221 | |
| 1 | 895 | 8.8% |
| 18 | 41 | 0.4% |
| 24 | 38 | 0.4% |
| 36 | 34 | 0.3% |
| 30 | 28 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 895 | 8.8% |
| 2 | 1221 | |
| 3 | 2264 | |
| 4 | 1874 | |
| 5 | 1863 | |
| 6 | 1847 | |
| 12 | 22 | 0.2% |
| 18 | 41 | 0.4% |
| 24 | 38 | 0.4% |
| 30 | 28 | 0.3% |
| Value | Count | Frequency (%) |
| 36 | 34 | 0.3% |
| 30 | 28 | 0.3% |
| 24 | 38 | 0.4% |
| 18 | 41 | 0.4% |
| 12 | 22 | 0.2% |
| 6 | 1847 | |
| 5 | 1863 | |
| 4 | 1874 | |
| 3 | 2264 | |
| 2 | 1221 |
period_inactive
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.3411672 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 29 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.0106224 |
|---|---|
| Coefficient of variation (CV) | 0.4316746 |
| Kurtosis | 1.0985226 |
| Mean | 2.3411672 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.63306113 |
| Sum | 23709 |
| Variance | 1.0213576 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 3 | 3846 | |
| 2 | 3282 | |
| 1 | 2233 | |
| 4 | 435 | 4.3% |
| 5 | 178 | 1.8% |
| 6 | 124 | 1.2% |
| 0 | 29 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 29 | 0.3% |
| 1 | 2233 | |
| 2 | 3282 | |
| 3 | 3846 | |
| 4 | 435 | 4.3% |
| 5 | 178 | 1.8% |
| 6 | 124 | 1.2% |
| Value | Count | Frequency (%) |
| 6 | 124 | 1.2% |
| 5 | 178 | 1.8% |
| 4 | 435 | 4.3% |
| 3 | 3846 | |
| 2 | 3282 | |
| 1 | 2233 | |
| 0 | 29 | 0.3% |
contacts_in_last_year
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4553175 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 399 |
| Zeros (%) | 3.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.1062251 |
|---|---|
| Coefficient of variation (CV) | 0.45054261 |
| Kurtosis | 0.00086265663 |
| Mean | 2.4553175 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.011005626 |
| Sum | 24865 |
| Variance | 1.2237341 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 3 | 3380 | |
| 2 | 3227 | |
| 1 | 1499 | |
| 4 | 1392 | |
| 0 | 399 | 3.9% |
| 5 | 176 | 1.7% |
| 6 | 54 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 399 | 3.9% |
| 1 | 1499 | |
| 2 | 3227 | |
| 3 | 3380 | |
| 4 | 1392 | |
| 5 | 176 | 1.7% |
| 6 | 54 | 0.5% |
| Value | Count | Frequency (%) |
| 6 | 54 | 0.5% |
| 5 | 176 | 1.7% |
| 4 | 1392 | |
| 3 | 3380 | |
| 2 | 3227 | |
| 1 | 1499 | |
| 0 | 399 | 3.9% |
credit_card_debt_balance
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1974 |
|---|---|
| Distinct (%) | 19.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1162.8141 |
| Minimum | 0 |
|---|---|
| Maximum | 2517 |
| Zeros | 2470 |
| Zeros (%) | 24.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 359 |
| median | 1276 |
| Q3 | 1784 |
| 95-th percentile | 2517 |
| Maximum | 2517 |
| Range | 2517 |
| Interquartile range (IQR) | 1425 |
Descriptive statistics
| Standard deviation | 814.98734 |
|---|---|
| Coefficient of variation (CV) | 0.70087503 |
| Kurtosis | -1.1459918 |
| Mean | 1162.8141 |
| Median Absolute Deviation (MAD) | 591 |
| Skewness | -0.14883725 |
| Sum | 11775818 |
| Variance | 664204.36 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2470 | 24.4% |
| 2517 | 508 | 5.0% |
| 1480 | 12 | 0.1% |
| 1965 | 12 | 0.1% |
| 1434 | 11 | 0.1% |
| 1720 | 11 | 0.1% |
| 1664 | 11 | 0.1% |
| 1482 | 10 | 0.1% |
| 1590 | 10 | 0.1% |
| 1250 | 10 | 0.1% |
| Other values (1964) | 7062 |
| Value | Count | Frequency (%) |
| 0 | 2470 | |
| 132 | 1 | < 0.1% |
| 134 | 1 | < 0.1% |
| 145 | 1 | < 0.1% |
| 154 | 1 | < 0.1% |
| 157 | 1 | < 0.1% |
| 159 | 2 | < 0.1% |
| 168 | 2 | < 0.1% |
| 170 | 1 | < 0.1% |
| 186 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2517 | 508 | |
| 2514 | 3 | < 0.1% |
| 2513 | 1 | < 0.1% |
| 2512 | 2 | < 0.1% |
| 2511 | 1 | < 0.1% |
| 2509 | 2 | < 0.1% |
| 2508 | 2 | < 0.1% |
| 2507 | 4 | < 0.1% |
| 2506 | 1 | < 0.1% |
| 2505 | 3 | < 0.1% |
remaining_credit_limit
Real number (ℝ)
| Distinct | 6813 |
|---|---|
| Distinct (%) | 67.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7469.1396 |
| Minimum | 3 |
|---|---|
| Maximum | 34516 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 480.3 |
| Q1 | 1324.5 |
| median | 3474 |
| Q3 | 9859 |
| 95-th percentile | 32183.4 |
| Maximum | 34516 |
| Range | 34513 |
| Interquartile range (IQR) | 8534.5 |
Descriptive statistics
| Standard deviation | 9090.6853 |
|---|---|
| Coefficient of variation (CV) | 1.2170994 |
| Kurtosis | 1.7986173 |
| Mean | 7469.1396 |
| Median Absolute Deviation (MAD) | 2665 |
| Skewness | 1.6616965 |
| Sum | 75639977 |
| Variance | 82640560 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1438.3 | 324 | 3.2% |
| 34516 | 98 | 1.0% |
| 31999 | 26 | 0.3% |
| 787 | 8 | 0.1% |
| 463 | 7 | 0.1% |
| 713 | 7 | 0.1% |
| 953 | 7 | 0.1% |
| 701 | 7 | 0.1% |
| 740 | 6 | 0.1% |
| 1623 | 6 | 0.1% |
| Other values (6803) | 9631 |
| Value | Count | Frequency (%) |
| 3 | 1 | |
| 10 | 1 | |
| 14 | 2 | |
| 15 | 1 | |
| 24 | 1 | |
| 28 | 1 | |
| 29 | 1 | |
| 36 | 1 | |
| 39 | 2 | |
| 41 | 2 |
| Value | Count | Frequency (%) |
| 34516 | 98 | |
| 34362 | 1 | < 0.1% |
| 34302 | 1 | < 0.1% |
| 34300 | 1 | < 0.1% |
| 34297 | 1 | < 0.1% |
| 34286 | 1 | < 0.1% |
| 34238 | 1 | < 0.1% |
| 34227 | 1 | < 0.1% |
| 34140 | 1 | < 0.1% |
| 34119 | 1 | < 0.1% |
transaction_amount_ratio
Real number (ℝ)
| Distinct | 1158 |
|---|---|
| Distinct (%) | 11.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.75994065 |
| Minimum | 0 |
|---|---|
| Maximum | 3.397 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.463 |
| Q1 | 0.631 |
| median | 0.736 |
| Q3 | 0.859 |
| 95-th percentile | 1.103 |
| Maximum | 3.397 |
| Range | 3.397 |
| Interquartile range (IQR) | 0.228 |
Descriptive statistics
| Standard deviation | 0.21920677 |
|---|---|
| Coefficient of variation (CV) | 0.28845248 |
| Kurtosis | 9.9935012 |
| Mean | 0.75994065 |
| Median Absolute Deviation (MAD) | 0.114 |
| Skewness | 1.7320634 |
| Sum | 7695.919 |
| Variance | 0.048051608 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.791 | 36 | 0.4% |
| 0.712 | 34 | 0.3% |
| 0.743 | 34 | 0.3% |
| 0.718 | 33 | 0.3% |
| 0.735 | 33 | 0.3% |
| 0.744 | 32 | 0.3% |
| 0.722 | 32 | 0.3% |
| 0.699 | 32 | 0.3% |
| 0.69 | 31 | 0.3% |
| 0.631 | 31 | 0.3% |
| Other values (1148) | 9799 |
| Value | Count | Frequency (%) |
| 0 | 5 | |
| 0.01 | 1 | < 0.1% |
| 0.018 | 1 | < 0.1% |
| 0.046 | 1 | < 0.1% |
| 0.061 | 2 | < 0.1% |
| 0.072 | 1 | < 0.1% |
| 0.101 | 1 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| 0.153 | 1 | < 0.1% |
| 0.163 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3.397 | 1 | |
| 3.355 | 1 | |
| 2.675 | 1 | |
| 2.594 | 1 | |
| 2.368 | 1 | |
| 2.357 | 1 | |
| 2.316 | 1 | |
| 2.282 | 1 | |
| 2.275 | 1 | |
| 2.271 | 1 |
total_transaction_amount
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 5141 |
|---|---|
| Distinct (%) | 52.9% |
| Missing | 407 |
| Missing (%) | 4.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5253.7119 |
| Minimum | 510 |
|---|---|
| Maximum | 117159 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 510 |
|---|---|
| 5-th percentile | 1289.95 |
| Q1 | 2196 |
| median | 3971 |
| Q3 | 4823 |
| 95-th percentile | 14994.25 |
| Maximum | 117159 |
| Range | 116649 |
| Interquartile range (IQR) | 2627 |
Descriptive statistics
| Standard deviation | 7402.2599 |
|---|---|
| Coefficient of variation (CV) | 1.4089581 |
| Kurtosis | 95.20208 |
| Mean | 5253.7119 |
| Median Absolute Deviation (MAD) | 1404 |
| Skewness | 8.2080929 |
| Sum | 51066080 |
| Variance | 54793452 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4253 | 11 | 0.1% |
| 4509 | 10 | 0.1% |
| 4518 | 9 | 0.1% |
| 4037 | 9 | 0.1% |
| 2229 | 9 | 0.1% |
| 4498 | 9 | 0.1% |
| 4313 | 9 | 0.1% |
| 4869 | 8 | 0.1% |
| 4674 | 8 | 0.1% |
| 4220 | 8 | 0.1% |
| Other values (5131) | 9630 | |
| (Missing) | 407 | 4.0% |
| Value | Count | Frequency (%) |
| 510 | 1 | |
| 530 | 1 | |
| 563 | 1 | |
| 569 | 1 | |
| 594 | 1 | |
| 596 | 1 | |
| 597 | 1 | |
| 602 | 1 | |
| 615 | 1 | |
| 643 | 1 |
| Value | Count | Frequency (%) |
| 117159 | 1 | |
| 114233 | 1 | |
| 113806 | 1 | |
| 108864 | 1 | |
| 108591 | 1 | |
| 108101 | 1 | |
| 107793 | 1 | |
| 106701 | 1 | |
| 106582 | 1 | |
| 105273 | 1 |
total_transaction_count
Real number (ℝ)
| Distinct | 126 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64.858695 |
| Minimum | 10 |
|---|---|
| Maximum | 139 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 28 |
| Q1 | 45 |
| median | 67 |
| Q3 | 81 |
| 95-th percentile | 105 |
| Maximum | 139 |
| Range | 129 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 23.47257 |
|---|---|
| Coefficient of variation (CV) | 0.36190322 |
| Kurtosis | -0.36716324 |
| Mean | 64.858695 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 0.15367307 |
| Sum | 656824 |
| Variance | 550.96156 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 81 | 208 | 2.1% |
| 75 | 203 | 2.0% |
| 71 | 203 | 2.0% |
| 69 | 202 | 2.0% |
| 82 | 202 | 2.0% |
| 76 | 198 | 2.0% |
| 77 | 197 | 1.9% |
| 70 | 193 | 1.9% |
| 78 | 190 | 1.9% |
| 74 | 190 | 1.9% |
| Other values (116) | 8141 |
| Value | Count | Frequency (%) |
| 10 | 4 | < 0.1% |
| 11 | 2 | < 0.1% |
| 12 | 4 | < 0.1% |
| 13 | 5 | < 0.1% |
| 14 | 9 | 0.1% |
| 15 | 16 | |
| 16 | 13 | |
| 17 | 13 | |
| 18 | 23 | |
| 19 | 11 |
| Value | Count | Frequency (%) |
| 139 | 1 | < 0.1% |
| 138 | 1 | < 0.1% |
| 134 | 1 | < 0.1% |
| 132 | 1 | < 0.1% |
| 131 | 6 | |
| 130 | 5 | |
| 129 | 6 | |
| 128 | 10 | |
| 127 | 12 | |
| 126 | 10 |
transaction_count_ratio
Real number (ℝ)
| Distinct | 1071 |
|---|---|
| Distinct (%) | 10.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.81754439 |
| Minimum | 0 |
|---|---|
| Maximum | 16.25 |
| Zeros | 7 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.3713 |
| Q1 | 0.588 |
| median | 0.711 |
| Q3 | 0.838 |
| 95-th percentile | 1.3817 |
| Maximum | 16.25 |
| Range | 16.25 |
| Interquartile range (IQR) | 0.25 |
Descriptive statistics
| Standard deviation | 0.61990619 |
|---|---|
| Coefficient of variation (CV) | 0.75825387 |
| Kurtosis | 60.398502 |
| Mean | 0.81754439 |
| Median Absolute Deviation (MAD) | 0.124 |
| Skewness | 5.7033308 |
| Sum | 8279.272 |
| Variance | 0.38428369 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 163 | 1.6% |
| 0.667 | 159 | 1.6% |
| 0.5 | 156 | 1.5% |
| 0.75 | 147 | 1.5% |
| 0.6 | 109 | 1.1% |
| 0.8 | 95 | 0.9% |
| 0.714 | 91 | 0.9% |
| 0.833 | 82 | 0.8% |
| 0.778 | 67 | 0.7% |
| 0.625 | 61 | 0.6% |
| Other values (1061) | 8997 |
| Value | Count | Frequency (%) |
| 0 | 7 | |
| 0.028 | 1 | < 0.1% |
| 0.029 | 1 | < 0.1% |
| 0.038 | 1 | < 0.1% |
| 0.053 | 1 | < 0.1% |
| 0.059 | 2 | < 0.1% |
| 0.062 | 1 | < 0.1% |
| 0.074 | 1 | < 0.1% |
| 0.077 | 3 | |
| 0.091 | 3 |
| Value | Count | Frequency (%) |
| 16.25 | 1 | |
| 8.75 | 1 | |
| 7.855 | 1 | |
| 6.175 | 1 | |
| 5.945 | 1 | |
| 5.87 | 1 | |
| 5.835 | 1 | |
| 5.64 | 1 | |
| 5.455 | 1 | |
| 5.385 | 1 |
average_utilization
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 964 |
|---|---|
| Distinct (%) | 9.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.27489355 |
| Minimum | 0 |
|---|---|
| Maximum | 0.999 |
| Zeros | 2470 |
| Zeros (%) | 24.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.023 |
| median | 0.176 |
| Q3 | 0.503 |
| 95-th percentile | 0.793 |
| Maximum | 0.999 |
| Range | 0.999 |
| Interquartile range (IQR) | 0.48 |
Descriptive statistics
| Standard deviation | 0.27569147 |
|---|---|
| Coefficient of variation (CV) | 1.0029026 |
| Kurtosis | -0.79497195 |
| Mean | 0.27489355 |
| Median Absolute Deviation (MAD) | 0.176 |
| Skewness | 0.718008 |
| Sum | 2783.847 |
| Variance | 0.076005786 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2470 | 24.4% |
| 0.073 | 44 | 0.4% |
| 0.057 | 33 | 0.3% |
| 0.048 | 32 | 0.3% |
| 0.06 | 30 | 0.3% |
| 0.045 | 29 | 0.3% |
| 0.061 | 29 | 0.3% |
| 0.069 | 28 | 0.3% |
| 0.059 | 28 | 0.3% |
| 0.053 | 27 | 0.3% |
| Other values (954) | 7377 |
| Value | Count | Frequency (%) |
| 0 | 2470 | |
| 0.004 | 1 | < 0.1% |
| 0.005 | 1 | < 0.1% |
| 0.006 | 3 | < 0.1% |
| 0.007 | 1 | < 0.1% |
| 0.008 | 2 | < 0.1% |
| 0.009 | 1 | < 0.1% |
| 0.01 | 1 | < 0.1% |
| 0.011 | 1 | < 0.1% |
| 0.012 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.999 | 1 | < 0.1% |
| 0.995 | 1 | < 0.1% |
| 0.994 | 1 | < 0.1% |
| 0.992 | 1 | < 0.1% |
| 0.99 | 1 | < 0.1% |
| 0.988 | 1 | < 0.1% |
| 0.987 | 1 | < 0.1% |
| 0.985 | 1 | < 0.1% |
| 0.984 | 1 | < 0.1% |
| 0.983 | 4 |
account_status
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.2 KiB |
| open | |
|---|---|
| closed |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.3213192 |
| Min length | 4 |
Characters and Unicode
| Total characters | 43762 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | open |
|---|---|
| 2nd row | closed |
| 3rd row | open |
| 4th row | open |
| 5th row | open |
Common Values
| Value | Count | Frequency (%) |
| open | 8500 | |
| closed | 1627 | 16.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| open | 8500 | |
| closed | 1627 | 16.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 10127 | |
| e | 10127 | |
| p | 8500 | |
| n | 8500 | |
| c | 1627 | 3.7% |
| l | 1627 | 3.7% |
| s | 1627 | 3.7% |
| d | 1627 | 3.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 43762 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 10127 | |
| e | 10127 | |
| p | 8500 | |
| n | 8500 | |
| c | 1627 | 3.7% |
| l | 1627 | 3.7% |
| s | 1627 | 3.7% |
| d | 1627 | 3.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 43762 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 10127 | |
| e | 10127 | |
| p | 8500 | |
| n | 8500 | |
| c | 1627 | 3.7% |
| l | 1627 | 3.7% |
| s | 1627 | 3.7% |
| d | 1627 | 3.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43762 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 10127 | |
| e | 10127 | |
| p | 8500 | |
| n | 8500 | |
| c | 1627 | 3.7% |
| l | 1627 | 3.7% |
| s | 1627 | 3.7% |
| d | 1627 | 3.7% |
| customer_id | customer_age | customer_number_of_dependents | customer_relationship_length | customer_available_credit_limit | total_products | period_inactive | contacts_in_last_year | credit_card_debt_balance | remaining_credit_limit | transaction_amount_ratio | total_transaction_amount | total_transaction_count | transaction_count_ratio | average_utilization | customer_sex | customer_education | customer_civil_status | customer_salary_range | credit_card_classification | account_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_id | 1.000 | -0.005 | 0.010 | -0.001 | 0.012 | -0.006 | 0.025 | -0.003 | 0.002 | 0.007 | -0.005 | -0.005 | 0.003 | -0.002 | -0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.022 |
| customer_age | -0.005 | 1.000 | -0.141 | 0.769 | 0.004 | -0.017 | 0.042 | -0.015 | 0.012 | -0.002 | -0.070 | -0.033 | -0.052 | -0.032 | 0.010 | 0.000 | 0.016 | 0.080 | 0.083 | 0.023 | 0.022 |
| customer_number_of_dependents | 0.010 | -0.141 | 1.000 | -0.115 | 0.045 | -0.037 | -0.009 | -0.041 | -0.004 | 0.054 | -0.026 | 0.056 | 0.053 | 0.006 | -0.035 | 0.008 | 0.001 | 0.037 | 0.046 | 0.018 | 0.021 |
| customer_relationship_length | -0.001 | 0.769 | -0.115 | 1.000 | 0.009 | -0.015 | 0.057 | -0.008 | 0.006 | 0.008 | -0.054 | -0.029 | -0.039 | -0.032 | -0.004 | 0.000 | 0.002 | 0.043 | 0.046 | 0.013 | 0.019 |
| customer_available_credit_limit | 0.012 | 0.004 | 0.045 | 0.009 | 1.000 | -0.054 | -0.025 | 0.024 | 0.125 | 0.905 | 0.021 | 0.025 | 0.032 | -0.005 | -0.408 | 0.219 | 0.000 | 0.020 | 0.165 | 0.290 | 0.000 |
| total_products | -0.006 | -0.017 | -0.037 | -0.015 | -0.054 | 1.000 | -0.010 | 0.063 | 0.017 | -0.065 | 0.022 | -0.258 | -0.219 | 0.026 | 0.065 | 0.012 | 0.007 | 0.000 | 0.000 | 0.025 | 0.097 |
| period_inactive | 0.025 | 0.042 | -0.009 | 0.057 | -0.025 | -0.010 | 1.000 | 0.030 | -0.043 | -0.016 | -0.019 | -0.027 | -0.051 | -0.046 | -0.027 | 0.012 | 0.000 | 0.007 | 0.020 | 0.000 | 0.196 |
| contacts_in_last_year | -0.003 | -0.015 | -0.041 | -0.008 | 0.024 | 0.063 | 0.030 | 1.000 | -0.045 | 0.033 | -0.021 | -0.162 | -0.168 | -0.083 | -0.059 | 0.064 | 0.000 | 0.007 | 0.015 | 0.010 | 0.239 |
| credit_card_debt_balance | 0.002 | 0.012 | -0.004 | 0.006 | 0.125 | 0.017 | -0.043 | -0.045 | 1.000 | -0.154 | 0.036 | 0.018 | 0.040 | 0.071 | 0.709 | 0.030 | 0.007 | 0.012 | 0.024 | 0.019 | 0.402 |
| remaining_credit_limit | 0.007 | -0.002 | 0.054 | 0.008 | 0.905 | -0.065 | -0.016 | 0.033 | -0.154 | 1.000 | 0.007 | 0.022 | 0.022 | -0.032 | -0.686 | 0.442 | 0.000 | 0.028 | 0.277 | 0.337 | 0.019 |
| transaction_amount_ratio | -0.005 | -0.070 | -0.026 | -0.054 | 0.021 | 0.022 | -0.019 | -0.021 | 0.036 | 0.007 | 1.000 | 0.128 | 0.085 | 0.276 | 0.033 | 0.044 | 0.000 | 0.053 | 0.013 | 0.024 | 0.184 |
| total_transaction_amount | -0.005 | -0.033 | 0.056 | -0.029 | 0.025 | -0.258 | -0.027 | -0.162 | 0.018 | 0.022 | 0.128 | 1.000 | 0.831 | 0.189 | 0.017 | 0.083 | 0.000 | 0.024 | 0.033 | 0.101 | 0.111 |
| total_transaction_count | 0.003 | -0.052 | 0.053 | -0.039 | 0.032 | -0.219 | -0.051 | -0.168 | 0.040 | 0.022 | 0.085 | 0.831 | 1.000 | 0.215 | 0.040 | 0.167 | 0.004 | 0.099 | 0.054 | 0.109 | 0.458 |
| transaction_count_ratio | -0.002 | -0.032 | 0.006 | -0.032 | -0.005 | 0.026 | -0.046 | -0.083 | 0.071 | -0.032 | 0.276 | 0.189 | 0.215 | 1.000 | 0.082 | 0.012 | 0.000 | 0.000 | 0.008 | 0.000 | 0.019 |
| average_utilization | -0.000 | 0.010 | -0.035 | -0.004 | -0.408 | 0.065 | -0.027 | -0.059 | 0.709 | -0.686 | 0.033 | 0.017 | 0.040 | 0.082 | 1.000 | 0.283 | 0.000 | 0.027 | 0.163 | 0.149 | 0.241 |
| customer_sex | 0.000 | 0.000 | 0.008 | 0.000 | 0.219 | 0.012 | 0.012 | 0.064 | 0.030 | 0.442 | 0.044 | 0.083 | 0.167 | 0.012 | 0.283 | 1.000 | 0.012 | 0.009 | 0.836 | 0.086 | 0.032 |
| customer_education | 0.000 | 0.016 | 0.001 | 0.002 | 0.000 | 0.007 | 0.000 | 0.000 | 0.007 | 0.000 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.012 | 1.000 | 0.011 | 0.021 | 0.000 | 0.025 |
| customer_civil_status | 0.000 | 0.080 | 0.037 | 0.043 | 0.020 | 0.000 | 0.007 | 0.007 | 0.012 | 0.028 | 0.053 | 0.024 | 0.099 | 0.000 | 0.027 | 0.009 | 0.011 | 1.000 | 0.000 | 0.028 | 0.017 |
| customer_salary_range | 0.000 | 0.083 | 0.046 | 0.046 | 0.165 | 0.000 | 0.020 | 0.015 | 0.024 | 0.277 | 0.013 | 0.033 | 0.054 | 0.008 | 0.163 | 0.836 | 0.021 | 0.000 | 1.000 | 0.052 | 0.029 |
| credit_card_classification | 0.000 | 0.023 | 0.018 | 0.013 | 0.290 | 0.025 | 0.000 | 0.010 | 0.019 | 0.337 | 0.024 | 0.101 | 0.109 | 0.000 | 0.149 | 0.086 | 0.000 | 0.028 | 0.052 | 1.000 | 0.000 |
| account_status | 0.022 | 0.022 | 0.021 | 0.019 | 0.000 | 0.097 | 0.196 | 0.239 | 0.402 | 0.019 | 0.184 | 0.111 | 0.458 | 0.019 | 0.241 | 0.032 | 0.025 | 0.017 | 0.029 | 0.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| customer_id | customer_age | customer_sex | customer_number_of_dependents | customer_education | customer_civil_status | customer_salary_range | customer_relationship_length | customer_available_credit_limit | credit_card_classification | total_products | period_inactive | contacts_in_last_year | credit_card_debt_balance | remaining_credit_limit | transaction_amount_ratio | total_transaction_amount | total_transaction_count | transaction_count_ratio | average_utilization | account_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 755410 | 38.0 | F | 2 | High School | Married | 40-60K | 31 | 1593.0 | Blue | 4 | 2 | 4 | 1091 | 502.0 | 0.870 | 4136.0 | 67 | 0.718 | 0.685 | open |
| 1 | 568093 | 46.0 | F | 2 | Graduate | Unknown | below 40K | 40 | 6568.0 | Blue | 5 | 2 | 2 | 0 | 6568.0 | 0.101 | 1507.0 | 33 | 0.222 | 0.000 | closed |
| 2 | 595389 | 43.0 | M | 1 | High School | Married | 80-120K | 30 | 34516.0 | Silver | 1 | 1 | 3 | 2045 | 32471.0 | 0.590 | 4081.0 | 54 | 0.421 | 0.059 | open |
| 3 | 287252 | 46.0 | F | 4 | High School | Married | below 40K | 36 | 2374.0 | Blue | 5 | 2 | 1 | 1332 | 1042.0 | 0.686 | 4253.0 | 81 | 0.884 | 0.561 | open |
| 4 | 231901 | 40.0 | M | 4 | High School | Single | 80-120K | 29 | 12978.0 | Blue | 3 | 3 | 2 | 0 | 12978.0 | 0.628 | 14134.0 | 85 | 0.700 | 0.000 | open |
| 5 | 418821 | 51.0 | M | 4 | High School | Married | 80-120K | 42 | 14438.0 | Blue | 6 | 1 | 2 | 2517 | 11921.0 | 0.853 | 2090.0 | 47 | 0.880 | 0.174 | open |
| 6 | 896187 | 45.0 | F | 3 | Uneducated | Single | below 40K | 39 | 2551.0 | Blue | 5 | 4 | 1 | 2253 | 298.0 | 0.688 | NaN | 63 | 0.909 | 0.883 | open |
| 7 | 258495 | 50.0 | F | 1 | High School | Single | below 40K | 36 | 4517.0 | Blue | 1 | 1 | 3 | 2238 | 2279.0 | 0.625 | 4686.0 | 81 | 0.761 | 0.495 | open |
| 8 | 881720 | 45.0 | F | 5 | Unknown | Married | Unknown | 40 | 14728.0 | Blue | 3 | 2 | 2 | 0 | 14728.0 | 0.708 | 4660.0 | 85 | 0.735 | 0.000 | open |
| 9 | 367251 | 40.0 | F | 2 | Graduate | Unknown | below 40K | 29 | 2636.0 | Blue | 5 | 1 | 2 | 1953 | 683.0 | 0.916 | 4584.0 | 70 | 0.591 | 0.741 | open |
| customer_id | customer_age | customer_sex | customer_number_of_dependents | customer_education | customer_civil_status | customer_salary_range | customer_relationship_length | customer_available_credit_limit | credit_card_classification | total_products | period_inactive | contacts_in_last_year | credit_card_debt_balance | remaining_credit_limit | transaction_amount_ratio | total_transaction_amount | total_transaction_count | transaction_count_ratio | average_utilization | account_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10117 | 378944 | 37.0 | F | 3 | Unknown | Married | below 40K | 25 | 1438.3 | Blue | 6 | 2 | 1 | 674 | 764.3 | 2.180 | 1717.0 | 31 | 0.722 | 0.469 | open |
| 10118 | 948201 | 41.0 | NaN | 4 | High School | Single | 60-80K | 28 | 4475.0 | Blue | 6 | 1 | 4 | 0 | 4475.0 | 0.706 | 3367.0 | 66 | 0.737 | 0.000 | open |
| 10119 | 476816 | 48.0 | F | 2 | Uneducated | Unknown | below 40K | 42 | 2055.0 | Blue | 3 | 2 | 2 | 0 | 2055.0 | 1.064 | 25592.0 | 63 | 0.750 | 0.000 | open |
| 10120 | 527751 | NaN | M | 4 | Post-Graduate | Married | 40-60K | 36 | 2219.0 | Blue | 1 | 2 | 2 | 1180 | 1039.0 | 0.768 | 8686.0 | 91 | 0.625 | 0.532 | open |
| 10121 | 921463 | 48.0 | F | 5 | Post-Graduate | Married | below 40K | 40 | 1438.3 | Blue | 3 | 3 | 3 | 665 | 773.3 | 0.750 | 4100.0 | 84 | 0.615 | 0.462 | open |
| 10122 | 435491 | NaN | F | 2 | High School | Single | 40-60K | 36 | 1677.0 | Blue | 2 | 3 | 1 | 0 | 1677.0 | 0.700 | 4035.0 | 87 | 0.891 | 0.000 | open |
| 10123 | 136052 | 46.0 | F | 4 | Uneducated | Single | Unknown | 33 | 224541.0 | Blue | 3 | 3 | 3 | 1749 | 23200.0 | 0.626 | 4092.0 | 77 | 0.540 | 0.070 | open |
| 10124 | 336583 | 44.0 | M | 0 | High School | Single | 60-80K | 36 | 6606.0 | Blue | 6 | 3 | 2 | 2517 | 4089.0 | 0.825 | 4493.0 | 68 | 0.659 | 0.381 | open |
| 10125 | 817129 | 39.0 | F | 5 | Graduate | Single | below 40K | 28 | 2077.0 | Blue | 3 | 3 | 2 | 0 | 2077.0 | 0.590 | 3647.0 | 69 | 0.917 | 0.000 | open |
| 10126 | 404120 | 35.0 | M | 2 | Post-Graduate | Married | 40-60K | 21 | 2256.0 | Blue | 3 | 1 | 3 | 775 | 1481.0 | 0.879 | 1749.0 | 33 | 0.435 | 0.344 | open |